
Use NEXUS_DB

GO
--------------------------------------Insert---------------
CREATE PROC insertProduct
	@producName nvarchar(255) ,
	@producSecurityDeposit float,
	@producDescription nvarchar(500) 
AS
INSERT INTO  Product(producName,producSecurityDeposit,producDescription)
 VALUES(@producName,@producSecurityDeposit,@producDescription)

GO
---------------------------------------------------update-------------------
CREATE PROC updateProduct
	@productID int,
	@producName nvarchar(255) ,
	@producSecurityDeposit float,
	@producDescription nvarchar(500)
AS
UPDATE Product SET	
	producName =@producName,
	producSecurityDeposit=@producSecurityDeposit,
	producDescription =@producDescription
WHERE 	productID =@productID
GO
---------------------------------------Delete--------------------

CREATE PROC deleteProduct
	@productID int
AS
	DELETE FROM Product WHERE productID=@productID
GO
-------------------------------------------GetAll---------------------
CREATE PROC getAllProduct
AS
SELECT * from Product
GO
--------------------------------getProductByID---------------------
CREATE PROC getProductByID
	@productID int
AS
SELECT * from Product WHERE productID=@productID
GO


